Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$TABLESPACE

This view displays tablespace information from the control file.

Column | Datatype | Description
--- | --- | ---
`TS#` | `NUMBER` | Tablespace number
`NAME` | `VARCHAR2(30)` | Tablespace name
`INCLUDED_IN_DATABASE_BACKUP` | `VARCHAR2(3)` | Indicates whether the tablespace is included in full database backups using the `BACKUP DATABASE` RMAN command (`YES`) or not (`NO`). `NO` only if the `CONFIGURE EXCLUDE` RMAN command was used for this tablespace.
`BIGFILE` | `VARCHAR2(3)` | Indicates whether the tablespace is a bigfile tablespace (`YES`) or not (`NO`)
`FLASHBACK_ON` | `VARCHAR2(3)` | Indicates whether the tablespace participates in `FLASHBACK DATABASE` operations (`YES`) or not (`NO`)
`ENCRYPT_IN_BACKUP` | `VARCHAR2(3)` | Possible values are: `ON` - encryption is turned ON at tablespace level `OFF` - encryption is turned OFF at tablespace level `NULL` - encryption is neither explicitly turned on or off at tablespace level (default or when CLEARED).